Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 1081784 |
| Missing cells | 72736 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 1405 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 173.3 MiB |
| Average record size in memory | 168.0 B |
Variable types
| Text | 4 |
|---|---|
| Categorical | 4 |
| DateTime | 5 |
| Numeric | 7 |
| Dataset has 1405 (0.1%) duplicate rows | Duplicates |
Team has 21129 (2.0%) missing values | Missing |
Status has 16781 (1.6%) missing values | Missing |
TripDuration is highly skewed (γ1 = 348.0823194) | Skewed |
Reproduction
| Analysis started | 2024-04-16 08:08:35.779488 |
|---|---|
| Analysis finished | 2024-04-16 08:09:14.294004 |
| Duration | 38.51 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
OrderNumber
Text
| Distinct | 177708 |
|---|---|
| Distinct (%) | 16.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 9736056 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 15705 ? |
|---|---|
| Unique (%) | 1.5% |
Sample
| 1st row | TL9008453 |
|---|---|
| 2nd row | TL9008453 |
| 3rd row | TL9009105 |
| 4th row | TL9009105 |
| 5th row | TL9008550 |
| Value | Count | Frequency (%) |
| xe7047245 | 193 | < 0.1% |
| tl9031430 | 161 | < 0.1% |
| xe7003986 | 156 | < 0.1% |
| xe7010523 | 153 | < 0.1% |
| xe7009115 | 143 | < 0.1% |
| xe7005058 | 143 | < 0.1% |
| xe7041124 | 139 | < 0.1% |
| xe7008614 | 139 | < 0.1% |
| te8016426 | 135 | < 0.1% |
| te8009655 | 135 | < 0.1% |
| Other values (177698) | 1080287 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1811201 | |
| 7 | 896590 | |
| 9 | 854228 | |
| 1 | 680071 | 7.0% |
| 2 | 658163 | 6.8% |
| E | 638308 | 6.6% |
| T | 619934 | 6.4% |
| 8 | 616632 | 6.3% |
| 3 | 614807 | 6.3% |
| 4 | 546297 | 5.6% |
| Other values (5) | 1799825 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9736056 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1811201 | |
| 7 | 896590 | |
| 9 | 854228 | |
| 1 | 680071 | 7.0% |
| 2 | 658163 | 6.8% |
| E | 638308 | 6.6% |
| T | 619934 | 6.4% |
| 8 | 616632 | 6.3% |
| 3 | 614807 | 6.3% |
| 4 | 546297 | 5.6% |
| Other values (5) | 1799825 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9736056 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1811201 | |
| 7 | 896590 | |
| 9 | 854228 | |
| 1 | 680071 | 7.0% |
| 2 | 658163 | 6.8% |
| E | 638308 | 6.6% |
| T | 619934 | 6.4% |
| 8 | 616632 | 6.3% |
| 3 | 614807 | 6.3% |
| 4 | 546297 | 5.6% |
| Other values (5) | 1799825 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9736056 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1811201 | |
| 7 | 896590 | |
| 9 | 854228 | |
| 1 | 680071 | 7.0% |
| 2 | 658163 | 6.8% |
| E | 638308 | 6.6% |
| T | 619934 | 6.4% |
| 8 | 616632 | 6.3% |
| 3 | 614807 | 6.3% |
| 4 | 546297 | 5.6% |
| Other values (5) | 1799825 |
CUSTID
Text
| Distinct | 94 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.0000009 |
| Min length | 8 |
Characters and Unicode
| Total characters | 8654273 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 00-RE001 |
|---|---|
| 2nd row | 00-RE001 |
| 3rd row | 00-RE001 |
| 4th row | 00-RE001 |
| 5th row | 00-RE001 |
| Value | Count | Frequency (%) |
| 00-rp036 | 207563 | |
| 00-re001 | 174616 | |
| 00-rc044 | 168571 | |
| 00-rs035 | 109141 | |
| 00-rs174 | 58623 | 5.4% |
| 00-rs020 | 48087 | 4.4% |
| 00-ri046 | 44040 | 4.1% |
| 00-re111 | 39215 | 3.6% |
| 00-re006 | 33287 | 3.1% |
| 00-rb089 | 33285 | 3.1% |
| Other values (84) | 165356 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3364737 | |
| - | 1081784 | 12.5% |
| R | 1072042 | 12.4% |
| 4 | 470843 | 5.4% |
| 1 | 433871 | 5.0% |
| 6 | 370173 | 4.3% |
| 3 | 346585 | 4.0% |
| E | 284255 | 3.3% |
| P | 262974 | 3.0% |
| S | 226436 | 2.6% |
| Other values (22) | 740573 | 8.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8654273 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3364737 | |
| - | 1081784 | 12.5% |
| R | 1072042 | 12.4% |
| 4 | 470843 | 5.4% |
| 1 | 433871 | 5.0% |
| 6 | 370173 | 4.3% |
| 3 | 346585 | 4.0% |
| E | 284255 | 3.3% |
| P | 262974 | 3.0% |
| S | 226436 | 2.6% |
| Other values (22) | 740573 | 8.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8654273 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3364737 | |
| - | 1081784 | 12.5% |
| R | 1072042 | 12.4% |
| 4 | 470843 | 5.4% |
| 1 | 433871 | 5.0% |
| 6 | 370173 | 4.3% |
| 3 | 346585 | 4.0% |
| E | 284255 | 3.3% |
| P | 262974 | 3.0% |
| S | 226436 | 2.6% |
| Other values (22) | 740573 | 8.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8654273 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3364737 | |
| - | 1081784 | 12.5% |
| R | 1072042 | 12.4% |
| 4 | 470843 | 5.4% |
| 1 | 433871 | 5.0% |
| 6 | 370173 | 4.3% |
| 3 | 346585 | 4.0% |
| E | 284255 | 3.3% |
| P | 262974 | 3.0% |
| S | 226436 | 2.6% |
| Other values (22) | 740573 | 8.6% |
JOBTYPE
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
| EXPORT | |
|---|---|
| LOCAL | |
| IMPORT |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.72206 |
| Min length | 5 |
Characters and Unicode
| Total characters | 6190033 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LOCAL |
|---|---|
| 2nd row | LOCAL |
| 3rd row | LOCAL |
| 4th row | LOCAL |
| 5th row | LOCAL |
Common Values
| Value | Count | Frequency (%) |
| EXPORT | 638285 | |
| LOCAL | 300671 | |
| IMPORT | 142828 | 13.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| export | 638285 | |
| local | 300671 | |
| import | 142828 | 13.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 1081784 | |
| P | 781113 | |
| R | 781113 | |
| T | 781113 | |
| E | 638285 | |
| X | 638285 | |
| L | 601342 | |
| C | 300671 | 4.9% |
| A | 300671 | 4.9% |
| I | 142828 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6190033 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 1081784 | |
| P | 781113 | |
| R | 781113 | |
| T | 781113 | |
| E | 638285 | |
| X | 638285 | |
| L | 601342 | |
| C | 300671 | 4.9% |
| A | 300671 | 4.9% |
| I | 142828 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6190033 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 1081784 | |
| P | 781113 | |
| R | 781113 | |
| T | 781113 | |
| E | 638285 | |
| X | 638285 | |
| L | 601342 | |
| C | 300671 | 4.9% |
| A | 300671 | 4.9% |
| I | 142828 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6190033 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 1081784 | |
| P | 781113 | |
| R | 781113 | |
| T | 781113 | |
| E | 638285 | |
| X | 638285 | |
| L | 601342 | |
| C | 300671 | 4.9% |
| A | 300671 | 4.9% |
| I | 142828 | 2.3% |
Department
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
| XINHUA | |
|---|---|
| CHIEN | |
| MAIN | |
| EXPRESS | 24 |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 5.2604753 |
| Min length | 4 |
Characters and Unicode
| Total characters | 5690698 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHIEN |
|---|---|
| 2nd row | CHIEN |
| 3rd row | CHIEN |
| 4th row | CHIEN |
| 5th row | CHIEN |
Common Values
| Value | Count | Frequency (%) |
| XINHUA | 461826 | |
| CHIEN | 439838 | |
| MAIN | 180096 | 16.6% |
| EXPRESS | 24 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| xinhua | 461826 | |
| chien | 439838 | |
| main | 180096 | 16.6% |
| express | 24 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 1081760 | |
| N | 1081760 | |
| H | 901664 | |
| A | 641922 | |
| X | 461850 | |
| U | 461826 | |
| E | 439886 | |
| C | 439838 | |
| M | 180096 | 3.2% |
| S | 48 | < 0.1% |
| Other values (2) | 48 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5690698 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 1081760 | |
| N | 1081760 | |
| H | 901664 | |
| A | 641922 | |
| X | 461850 | |
| U | 461826 | |
| E | 439886 | |
| C | 439838 | |
| M | 180096 | 3.2% |
| S | 48 | < 0.1% |
| Other values (2) | 48 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5690698 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 1081760 | |
| N | 1081760 | |
| H | 901664 | |
| A | 641922 | |
| X | 461850 | |
| U | 461826 | |
| E | 439886 | |
| C | 439838 | |
| M | 180096 | 3.2% |
| S | 48 | < 0.1% |
| Other values (2) | 48 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5690698 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 1081760 | |
| N | 1081760 | |
| H | 901664 | |
| A | 641922 | |
| X | 461850 | |
| U | 461826 | |
| E | 439886 | |
| C | 439838 | |
| M | 180096 | 3.2% |
| S | 48 | < 0.1% |
| Other values (2) | 48 | < 0.1% |
FROMLOCSTR
Text
| Distinct | 487 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 8.3466089 |
| Min length | 2 |
Characters and Unicode
| Total characters | 9029228 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 73 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | JI DRUM |
|---|---|
| 2nd row | JI DRUM |
| 3rd row | JI DRUM |
| 4th row | JI DRUM |
| 5th row | JI DRUM |
| Value | Count | Frequency (%) |
| ptcisl | 124135 | 7.5% |
| off | 124127 | 7.5% |
| ptc | 76467 | 4.6% |
| j.island | 63829 | 3.9% |
| 100 | 56924 | 3.5% |
| pam | 56647 | 3.4% |
| g | 47174 | 2.9% |
| isl | 47172 | 2.9% |
| island(g | 45435 | 2.8% |
| ptcmrtgr | 40602 | 2.5% |
| Other values (495) | 962558 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 672190 | 7.4% |
| A | 664151 | 7.4% |
| T | 639609 | 7.1% |
| 563286 | 6.2% | |
| S | 533659 | 5.9% |
| N | 486815 | 5.4% |
| L | 476693 | 5.3% |
| I | 467112 | 5.2% |
| C | 466250 | 5.2% |
| R | 430838 | 4.8% |
| Other values (34) | 3628625 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9029228 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 672190 | 7.4% |
| A | 664151 | 7.4% |
| T | 639609 | 7.1% |
| 563286 | 6.2% | |
| S | 533659 | 5.9% |
| N | 486815 | 5.4% |
| L | 476693 | 5.3% |
| I | 467112 | 5.2% |
| C | 466250 | 5.2% |
| R | 430838 | 4.8% |
| Other values (34) | 3628625 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9029228 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 672190 | 7.4% |
| A | 664151 | 7.4% |
| T | 639609 | 7.1% |
| 563286 | 6.2% | |
| S | 533659 | 5.9% |
| N | 486815 | 5.4% |
| L | 476693 | 5.3% |
| I | 467112 | 5.2% |
| C | 466250 | 5.2% |
| R | 430838 | 4.8% |
| Other values (34) | 3628625 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9029228 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 672190 | 7.4% |
| A | 664151 | 7.4% |
| T | 639609 | 7.1% |
| 563286 | 6.2% | |
| S | 533659 | 5.9% |
| N | 486815 | 5.4% |
| L | 476693 | 5.3% |
| I | 467112 | 5.2% |
| C | 466250 | 5.2% |
| R | 430838 | 4.8% |
| Other values (34) | 3628625 |
TOLOCSTR
Text
| Distinct | 497 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
Length
| Max length | 17 |
|---|---|
| Median length | 14 |
| Mean length | 7.730779 |
| Min length | 2 |
Characters and Unicode
| Total characters | 8363033 |
|---|---|
| Distinct characters | 44 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 79 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 SERAYA AVE |
|---|---|
| 2nd row | 1 SERAYA AVE |
| 3rd row | 1 SERAYA AVE |
| 4th row | 1 SERAYA AVE |
| 5th row | 1 SERAYA AVE |
| Value | Count | Frequency (%) |
| ptcisl | 93227 | 6.1% |
| off | 93224 | 6.1% |
| ppt | 76135 | 5.0% |
| ptc | 72763 | 4.8% |
| j.island | 63626 | 4.2% |
| 100 | 56873 | 3.7% |
| pam | 56603 | 3.7% |
| island(g | 46150 | 3.0% |
| g | 45422 | 3.0% |
| isl | 45417 | 3.0% |
| Other values (508) | 874769 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 859245 | 10.3% |
| T | 701952 | 8.4% |
| A | 676468 | 8.1% |
| S | 542171 | 6.5% |
| 442426 | 5.3% | |
| N | 401077 | 4.8% |
| I | 398732 | 4.8% |
| L | 392782 | 4.7% |
| R | 368735 | 4.4% |
| C | 363627 | 4.3% |
| Other values (34) | 3215818 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8363033 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 859245 | 10.3% |
| T | 701952 | 8.4% |
| A | 676468 | 8.1% |
| S | 542171 | 6.5% |
| 442426 | 5.3% | |
| N | 401077 | 4.8% |
| I | 398732 | 4.8% |
| L | 392782 | 4.7% |
| R | 368735 | 4.4% |
| C | 363627 | 4.3% |
| Other values (34) | 3215818 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8363033 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 859245 | 10.3% |
| T | 701952 | 8.4% |
| A | 676468 | 8.1% |
| S | 542171 | 6.5% |
| 442426 | 5.3% | |
| N | 401077 | 4.8% |
| I | 398732 | 4.8% |
| L | 392782 | 4.7% |
| R | 368735 | 4.4% |
| C | 363627 | 4.3% |
| Other values (34) | 3215818 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8363033 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 859245 | 10.3% |
| T | 701952 | 8.4% |
| A | 676468 | 8.1% |
| S | 542171 | 6.5% |
| 442426 | 5.3% | |
| N | 401077 | 4.8% |
| I | 398732 | 4.8% |
| L | 392782 | 4.7% |
| R | 368735 | 4.4% |
| C | 363627 | 4.3% |
| Other values (34) | 3215818 |
STARTTM
Date
| Distinct | 194248 |
|---|---|
| Distinct (%) | 18.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
| Minimum | 2020-12-31 23:30:00 |
|---|---|
| Maximum | 2023-12-31 21:20:00 |
ENDTM
Date
| Distinct | 191366 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
| Minimum | 2021-01-01 00:00:00 |
|---|---|
| Maximum | 2023-12-31 21:40:00 |
TripDuration
Real number (ℝ)
SKEWED 
| Distinct | 451 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8950775 |
| Minimum | 0 |
|---|---|
| Maximum | 625 |
| Zeros | 5133 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.33333333 |
| Q1 | 0.33333333 |
| median | 0.83333333 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 625 |
| Range | 625 |
| Interquartile range (IQR) | 0.66666667 |
Descriptive statistics
| Standard deviation | 1.3726842 |
|---|---|
| Coefficient of variation (CV) | 1.5335925 |
| Kurtosis | 158010.72 |
| Mean | 0.8950775 |
| Median Absolute Deviation (MAD) | 0.33333333 |
| Skewness | 348.08232 |
| Sum | 968280.52 |
| Variance | 1.8842618 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 258761 | |
| 0.3333333333 | 252116 | |
| 0.5 | 220585 | |
| 1.5 | 107049 | |
| 2 | 61476 | 5.7% |
| 0.1666666667 | 25325 | 2.3% |
| 0.6666666667 | 14718 | 1.4% |
| 0.8333333333 | 12510 | 1.2% |
| 2.5 | 9164 | 0.8% |
| 1.333333333 | 7781 | 0.7% |
| Other values (441) | 112299 |
| Value | Count | Frequency (%) |
| 0 | 5133 | 0.5% |
| 0.1666666667 | 25325 | |
| 0.1833333333 | 13 | < 0.1% |
| 0.2 | 20 | < 0.1% |
| 0.2166666667 | 33 | < 0.1% |
| 0.2333333333 | 53 | < 0.1% |
| 0.25 | 2935 | 0.3% |
| 0.2666666667 | 106 | < 0.1% |
| 0.2833333333 | 108 | < 0.1% |
| 0.3 | 158 | < 0.1% |
| Value | Count | Frequency (%) |
| 625 | 4 | < 0.1% |
| 48.5 | 4 | < 0.1% |
| 25.81666667 | 2 | < 0.1% |
| 25 | 10 | |
| 24.75 | 8 | |
| 24.5 | 6 | |
| 24.33333333 | 2 | < 0.1% |
| 24.25 | 1 | < 0.1% |
| 24.16666667 | 3 | < 0.1% |
| 16.5 | 1 | < 0.1% |
CTCOMPLETEDT
Date
| Distinct | 1095 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
| Minimum | 2021-01-01 00:00:00 |
|---|---|
| Maximum | 2023-12-31 00:00:00 |
DriverId
Real number (ℝ)
| Distinct | 199 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 289.77487 |
| Minimum | 0 |
|---|---|
| Maximum | 594 |
| Zeros | 5133 |
| Zeros (%) | 0.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 41 |
| Q1 | 185 |
| median | 301 |
| Q3 | 384 |
| 95-th percentile | 508 |
| Maximum | 594 |
| Range | 594 |
| Interquartile range (IQR) | 199 |
Descriptive statistics
| Standard deviation | 144.08675 |
|---|---|
| Coefficient of variation (CV) | 0.49723688 |
| Kurtosis | -0.8071874 |
| Mean | 289.77487 |
| Median Absolute Deviation (MAD) | 97 |
| Skewness | -0.19430128 |
| Sum | 3.1347381 × 108 |
| Variance | 20760.992 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 220 | 32603 | 3.0% |
| 382 | 22678 | 2.1% |
| 128 | 19415 | 1.8% |
| 88 | 17690 | 1.6% |
| 293 | 16801 | 1.6% |
| 74 | 16623 | 1.5% |
| 326 | 14611 | 1.4% |
| 330 | 14273 | 1.3% |
| 375 | 13905 | 1.3% |
| 302 | 13763 | 1.3% |
| Other values (189) | 899422 |
| Value | Count | Frequency (%) |
| 0 | 5133 | |
| 2 | 499 | < 0.1% |
| 4 | 8935 | |
| 28 | 984 | 0.1% |
| 29 | 8824 | |
| 33 | 12062 | |
| 36 | 5617 | |
| 37 | 6365 | |
| 41 | 10070 | |
| 51 | 6870 |
| Value | Count | Frequency (%) |
| 594 | 73 | < 0.1% |
| 592 | 643 | 0.1% |
| 591 | 810 | 0.1% |
| 589 | 714 | 0.1% |
| 588 | 767 | 0.1% |
| 587 | 520 | < 0.1% |
| 586 | 700 | 0.1% |
| 583 | 2260 | |
| 582 | 1023 | |
| 580 | 1686 |
PrimeMoverId
Real number (ℝ)
| Distinct | 199 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 293.43551 |
| Minimum | 1 |
|---|---|
| Maximum | 1002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 103 |
| Q1 | 234 |
| median | 304 |
| Q3 | 363 |
| 95-th percentile | 418 |
| Maximum | 1002 |
| Range | 1001 |
| Interquartile range (IQR) | 129 |
Descriptive statistics
| Standard deviation | 105.49956 |
|---|---|
| Coefficient of variation (CV) | 0.35953237 |
| Kurtosis | 10.523302 |
| Mean | 293.43551 |
| Median Absolute Deviation (MAD) | 66 |
| Skewness | 1.0750358 |
| Sum | 3.1743384 × 108 |
| Variance | 11130.158 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 222 | 32607 | 3.0% |
| 384 | 17697 | 1.6% |
| 234 | 15437 | 1.4% |
| 257 | 15055 | 1.4% |
| 333 | 14611 | 1.4% |
| 392 | 13550 | 1.3% |
| 332 | 13466 | 1.2% |
| 258 | 12405 | 1.1% |
| 383 | 12017 | 1.1% |
| 218 | 11923 | 1.1% |
| Other values (189) | 923016 |
| Value | Count | Frequency (%) |
| 1 | 9905 | |
| 2 | 3429 | 0.3% |
| 10 | 4196 | 0.4% |
| 13 | 10598 | |
| 17 | 1 | < 0.1% |
| 22 | 2312 | 0.2% |
| 64 | 701 | 0.1% |
| 69 | 815 | 0.1% |
| 81 | 2730 | 0.3% |
| 85 | 678 | 0.1% |
| Value | Count | Frequency (%) |
| 1002 | 39 | < 0.1% |
| 1001 | 5094 | |
| 1000 | 868 | 0.1% |
| 484 | 1995 | 0.2% |
| 483 | 578 | 0.1% |
| 482 | 1046 | 0.1% |
| 481 | 842 | 0.1% |
| 480 | 1085 | 0.1% |
| 465 | 3454 | |
| 450 | 2893 |
TrailerId
Real number (ℝ)
| Distinct | 1470 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 6042 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1006.0034 |
| Minimum | 1 |
|---|---|
| Maximum | 1970 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 94 |
| Q1 | 635 |
| median | 1009 |
| Q3 | 1394 |
| 95-th percentile | 1819 |
| Maximum | 1970 |
| Range | 1969 |
| Interquartile range (IQR) | 759 |
Descriptive statistics
| Standard deviation | 523.33974 |
|---|---|
| Coefficient of variation (CV) | 0.52021666 |
| Kurtosis | -0.8724849 |
| Mean | 1006.0034 |
| Median Absolute Deviation (MAD) | 378 |
| Skewness | -0.1644765 |
| Sum | 1.0822001 × 109 |
| Variance | 273884.48 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1245 | 16470 | 1.5% |
| 989 | 14793 | 1.4% |
| 1132 | 13836 | 1.3% |
| 1028 | 12549 | 1.2% |
| 1243 | 10383 | 1.0% |
| 900 | 10007 | 0.9% |
| 1009 | 9856 | 0.9% |
| 994 | 9750 | 0.9% |
| 974 | 9052 | 0.8% |
| 965 | 7772 | 0.7% |
| Other values (1460) | 961274 |
| Value | Count | Frequency (%) |
| 1 | 738 | |
| 2 | 756 | |
| 3 | 1193 | |
| 4 | 499 | |
| 5 | 804 | |
| 6 | 599 | |
| 7 | 553 | |
| 8 | 569 | |
| 9 | 630 | |
| 10 | 730 |
| Value | Count | Frequency (%) |
| 1970 | 37 | < 0.1% |
| 1957 | 2 | < 0.1% |
| 1939 | 468 | |
| 1938 | 367 | |
| 1937 | 133 | < 0.1% |
| 1936 | 439 | |
| 1935 | 231 | |
| 1934 | 308 | |
| 1933 | 179 | < 0.1% |
| 1932 | 241 |
JOINED DATE
Date
| Distinct | 176 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7196 |
| Missing (%) | 0.7% |
| Memory size | 16.5 MiB |
| Minimum | 1980-01-01 00:00:00 |
|---|---|
| Maximum | 2023-11-27 00:00:00 |
RESIGNED DATE
Date
| Distinct | 71 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.5 MiB |
| Minimum | 2020-07-08 00:00:00 |
|---|---|
| Maximum | 2023-12-31 00:00:00 |
RACE
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7196 |
| Missing (%) | 0.7% |
| Memory size | 16.5 MiB |
| CHINESE | |
|---|---|
| MALAY | |
| MYANMAR | |
| INDIAN | 32717 |
| MALIAN | 3258 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.6575497 |
| Min length | 5 |
Characters and Unicode
| Total characters | 7154123 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHINESE |
|---|---|
| 2nd row | CHINESE |
| 3rd row | CHINESE |
| 4th row | CHINESE |
| 5th row | CHINESE |
Common Values
| Value | Count | Frequency (%) |
| CHINESE | 720872 | |
| MALAY | 166009 | 15.3% |
| MYANMAR | 151659 | 14.0% |
| INDIAN | 32717 | 3.0% |
| MALIAN | 3258 | 0.3% |
| Chinese | 73 | < 0.1% |
| (Missing) | 7196 | 0.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| chinese | 720945 | |
| malay | 166009 | 15.4% |
| myanmar | 151659 | 14.1% |
| indian | 32717 | 3.0% |
| malian | 3258 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 1441744 | |
| N | 941223 | |
| I | 789564 | |
| C | 720945 | |
| S | 720872 | |
| H | 720872 | |
| A | 674569 | |
| M | 472585 | 6.6% |
| Y | 317668 | 4.4% |
| L | 169267 | 2.4% |
| Other values (7) | 184814 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7154123 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| E | 1441744 | |
| N | 941223 | |
| I | 789564 | |
| C | 720945 | |
| S | 720872 | |
| H | 720872 | |
| A | 674569 | |
| M | 472585 | 6.6% |
| Y | 317668 | 4.4% |
| L | 169267 | 2.4% |
| Other values (7) | 184814 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7154123 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| E | 1441744 | |
| N | 941223 | |
| I | 789564 | |
| C | 720945 | |
| S | 720872 | |
| H | 720872 | |
| A | 674569 | |
| M | 472585 | 6.6% |
| Y | 317668 | 4.4% |
| L | 169267 | 2.4% |
| Other values (7) | 184814 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7154123 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| E | 1441744 | |
| N | 941223 | |
| I | 789564 | |
| C | 720945 | |
| S | 720872 | |
| H | 720872 | |
| A | 674569 | |
| M | 472585 | 6.6% |
| Y | 317668 | 4.4% |
| L | 169267 | 2.4% |
| Other values (7) | 184814 | 2.6% |
Team
Categorical
MISSING 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 21129 |
| Missing (%) | 2.0% |
| Memory size | 16.5 MiB |
| CHIEN LI | |
|---|---|
| FCL | |
| Team 5 | |
| Team 2 | |
| TRANSHIPMENT | |
| Other values (10) |
Length
| Max length | 25 |
|---|---|
| Median length | 19 |
| Mean length | 7.1372671 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7570178 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHIEN LI |
|---|---|
| 2nd row | CHIEN LI |
| 3rd row | CHIEN LI |
| 4th row | CHIEN LI |
| 5th row | CHIEN LI |
Common Values
| Value | Count | Frequency (%) |
| CHIEN LI | 421062 | |
| FCL | 176098 | |
| Team 5 | 113686 | 10.5% |
| Team 2 | 112589 | 10.4% |
| TRANSHIPMENT | 112588 | 10.4% |
| Team 1 | 36416 | 3.4% |
| Team 4 | 31497 | 2.9% |
| Team 3 | 20683 | 1.9% |
| Team 6 | 18631 | 1.7% |
| M&R – SPARE TRUCK | 14221 | 1.3% |
| Other values (5) | 3184 | 0.3% |
| (Missing) | 21129 | 2.0% |
Length
| Value | Count | Frequency (%) |
| chien | 421062 | |
| li | 421062 | |
| team | 333502 | |
| fcl | 176098 | |
| 5 | 113686 | 6.1% |
| 2 | 112589 | 6.0% |
| transhipment | 112588 | 6.0% |
| 1 | 36416 | 2.0% |
| 4 | 31497 | 1.7% |
| 3 | 20683 | 1.1% |
| Other values (14) | 82602 | 4.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 961643 | |
| 801130 | ||
| N | 652842 | |
| C | 614651 | 8.1% |
| L | 597649 | 7.9% |
| T | 576797 | 7.6% |
| E | 549857 | 7.3% |
| H | 536356 | 7.1% |
| e | 333502 | 4.4% |
| a | 333502 | 4.4% |
| Other values (24) | 1612249 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7570178 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 961643 | |
| 801130 | ||
| N | 652842 | |
| C | 614651 | 8.1% |
| L | 597649 | 7.9% |
| T | 576797 | 7.6% |
| E | 549857 | 7.3% |
| H | 536356 | 7.1% |
| e | 333502 | 4.4% |
| a | 333502 | 4.4% |
| Other values (24) | 1612249 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7570178 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 961643 | |
| 801130 | ||
| N | 652842 | |
| C | 614651 | 8.1% |
| L | 597649 | 7.9% |
| T | 576797 | 7.6% |
| E | 549857 | 7.3% |
| H | 536356 | 7.1% |
| e | 333502 | 4.4% |
| a | 333502 | 4.4% |
| Other values (24) | 1612249 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7570178 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 961643 | |
| 801130 | ||
| N | 652842 | |
| C | 614651 | 8.1% |
| L | 597649 | 7.9% |
| T | 576797 | 7.6% |
| E | 549857 | 7.3% |
| H | 536356 | 7.1% |
| e | 333502 | 4.4% |
| a | 333502 | 4.4% |
| Other values (24) | 1612249 |
Status
Real number (ℝ)
MISSING 
| Distinct | 63 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16781 |
| Missing (%) | 1.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.734014 |
| Minimum | 1 |
|---|---|
| Maximum | 65 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 12 |
| Q3 | 17 |
| 95-th percentile | 28 |
| Maximum | 65 |
| Range | 64 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 7.805027 |
|---|---|
| Coefficient of variation (CV) | 0.56829904 |
| Kurtosis | 5.0985979 |
| Mean | 13.734014 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.8234531 |
| Sum | 14626766 |
| Variance | 60.918446 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 86636 | 8.0% |
| 9 | 83782 | 7.7% |
| 10 | 79576 | 7.4% |
| 7 | 73314 | 6.8% |
| 11 | 68602 | 6.3% |
| 12 | 64428 | 6.0% |
| 6 | 55303 | 5.1% |
| 14 | 54823 | 5.1% |
| 16 | 52762 | 4.9% |
| 13 | 51833 | 4.8% |
| Other values (53) | 393944 |
| Value | Count | Frequency (%) |
| 1 | 1061 | 0.1% |
| 2 | 3639 | 0.3% |
| 3 | 7476 | 0.7% |
| 4 | 18542 | 1.7% |
| 5 | 32781 | 3.0% |
| 6 | 55303 | |
| 7 | 73314 | |
| 8 | 86636 | |
| 9 | 83782 | |
| 10 | 79576 |
| Value | Count | Frequency (%) |
| 65 | 130 | < 0.1% |
| 64 | 64 | < 0.1% |
| 62 | 62 | < 0.1% |
| 60 | 240 | |
| 59 | 236 | |
| 58 | 116 | < 0.1% |
| 57 | 171 | < 0.1% |
| 56 | 224 | |
| 55 | 440 | |
| 54 | 216 |
AGE_Years
Real number (ℝ)
| Distinct | 157 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7196 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.693303 |
| Minimum | 24.25 |
|---|---|
| Maximum | 76.33 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 24.25 |
|---|---|
| 5-th percentile | 33.83 |
| Q1 | 41.58 |
| median | 51.33 |
| Q3 | 58.25 |
| 95-th percentile | 67.67 |
| Maximum | 76.33 |
| Range | 52.08 |
| Interquartile range (IQR) | 16.67 |
Descriptive statistics
| Standard deviation | 10.790382 |
|---|---|
| Coefficient of variation (CV) | 0.21285615 |
| Kurtosis | -0.85579687 |
| Mean | 50.693303 |
| Median Absolute Deviation (MAD) | 7.67 |
| Skewness | -0.068269717 |
| Sum | 54474416 |
| Variance | 116.43234 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 51.33 | 46876 | 4.3% |
| 45.25 | 29992 | 2.8% |
| 49.83 | 25967 | 2.4% |
| 46.92 | 25301 | 2.3% |
| 37.83 | 22905 | 2.1% |
| 56.58 | 22678 | 2.1% |
| 55.75 | 22373 | 2.1% |
| 67.67 | 20036 | 1.9% |
| 56.42 | 19429 | 1.8% |
| 57.75 | 17690 | 1.6% |
| Other values (147) | 821341 |
| Value | Count | Frequency (%) |
| 24.25 | 326 | < 0.1% |
| 25.67 | 133 | < 0.1% |
| 25.83 | 3571 | |
| 26.08 | 504 | < 0.1% |
| 26.92 | 1868 | 0.2% |
| 27.42 | 4715 | |
| 28.92 | 1023 | 0.1% |
| 29 | 859 | 0.1% |
| 30.08 | 6831 | |
| 30.25 | 146 | < 0.1% |
| Value | Count | Frequency (%) |
| 76.33 | 3063 | 0.3% |
| 72.58 | 4005 | |
| 71.67 | 2151 | 0.2% |
| 71 | 609 | 0.1% |
| 70.17 | 3972 | |
| 70.08 | 429 | < 0.1% |
| 69.75 | 8123 | |
| 69.5 | 6870 | |
| 69.17 | 4788 | |
| 68.25 | 6365 |
Seniority
Real number (ℝ)
| Distinct | 175 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7196 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.347275 |
| Minimum | 0 |
|---|---|
| Maximum | 44 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.32 |
| Q1 | 5.13 |
| median | 9.39 |
| Q3 | 15.57 |
| 95-th percentile | 28.75 |
| Maximum | 44 |
| Range | 44 |
| Interquartile range (IQR) | 10.44 |
Descriptive statistics
| Standard deviation | 8.6402709 |
|---|---|
| Coefficient of variation (CV) | 0.76144014 |
| Kurtosis | 1.4465405 |
| Mean | 11.347275 |
| Median Absolute Deviation (MAD) | 5.7 |
| Skewness | 1.209368 |
| Sum | 12193646 |
| Variance | 74.654281 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.13 | 41241 | 3.8% |
| 15.79 | 32603 | 3.0% |
| 9.18 | 22678 | 2.1% |
| 15.36 | 19415 | 1.8% |
| 2.87 | 19235 | 1.8% |
| 25.08 | 17690 | 1.6% |
| 28.75 | 16623 | 1.5% |
| 1.7 | 14872 | 1.4% |
| 15.41 | 14611 | 1.4% |
| 9.68 | 14273 | 1.3% |
| Other values (165) | 861347 |
| Value | Count | Frequency (%) |
| 0 | 6 | < 0.1% |
| 0.01 | 133 | < 0.1% |
| 0.02 | 45 | < 0.1% |
| 0.03 | 36 | < 0.1% |
| 0.04 | 12 | < 0.1% |
| 0.05 | 17 | < 0.1% |
| 0.08 | 174 | < 0.1% |
| 0.09 | 73 | < 0.1% |
| 0.1 | 136 | < 0.1% |
| 0.18 | 3359 |
| Value | Count | Frequency (%) |
| 44 | 3972 | 0.4% |
| 41.91 | 609 | 0.1% |
| 37.5 | 9172 | |
| 37.22 | 11527 | |
| 36.9 | 10070 | |
| 31.46 | 4861 | 0.4% |
| 29.4 | 11203 | |
| 28.75 | 16623 | |
| 28.27 | 429 | < 0.1% |
| 26.78 | 5360 | 0.5% |
| OrderNumber | CUSTID | JOBTYPE | Department | FROMLOCSTR | TOLOCSTR | STARTTM | ENDTM | TripDuration | CTCOMPLETEDT | DriverId | PrimeMoverId | TrailerId | JOINED DATE | RESIGNED DATE | RACE | Team | Status | AGE_Years | Seniority | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | TL9008453 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-07 08:00:00 | 2021-01-07 08:30:00 | 0.5 | 2021-01-07 | 2 | 215 | 1538.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 16.0 | 53.58 | 13.72 |
| 1 | TL9008453 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-07 10:30:00 | 2021-01-07 11:00:00 | 0.5 | 2021-01-07 | 2 | 215 | 972.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 16.0 | 53.58 | 13.72 |
| 2 | TL9009105 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-27 08:00:00 | 2021-01-27 08:30:00 | 0.5 | 2021-01-27 | 2 | 215 | 972.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 6.0 | 53.58 | 13.72 |
| 3 | TL9009105 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-27 10:30:00 | 2021-01-27 11:00:00 | 0.5 | 2021-01-27 | 2 | 215 | 1538.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 6.0 | 53.58 | 13.72 |
| 4 | TL9008550 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-11 08:00:00 | 2021-01-11 08:30:00 | 0.5 | 2021-01-11 | 2 | 215 | 1538.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 13.0 | 53.58 | 13.72 |
| 5 | TL9008550 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-11 10:30:00 | 2021-01-11 11:00:00 | 0.5 | 2021-01-11 | 2 | 215 | 972.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 13.0 | 53.58 | 13.72 |
| 6 | TL9008474 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-08 08:00:00 | 2021-01-08 08:30:00 | 0.5 | 2021-01-08 | 2 | 215 | 972.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 12.0 | 53.58 | 13.72 |
| 7 | TL9008474 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-08 10:30:00 | 2021-01-08 11:00:00 | 0.5 | 2021-01-08 | 2 | 215 | 1538.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 12.0 | 53.58 | 13.72 |
| 8 | TL9008312 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-04 12:30:00 | 2021-01-04 13:00:00 | 0.5 | 2021-01-04 | 2 | 215 | 972.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 13.0 | 53.58 | 13.72 |
| 9 | TL9009052 | 00-RE001 | LOCAL | CHIEN | JI DRUM | 1 SERAYA AVE | 2021-01-26 10:30:00 | 2021-01-26 11:00:00 | 0.5 | 2021-01-26 | 2 | 215 | 972.0 | 2007-06-07 | 2021-02-23 | CHINESE | CHIEN LI | 24.0 | 53.58 | 13.72 |
| OrderNumber | CUSTID | JOBTYPE | Department | FROMLOCSTR | TOLOCSTR | STARTTM | ENDTM | TripDuration | CTCOMPLETEDT | DriverId | PrimeMoverId | TrailerId | JOINED DATE | RESIGNED DATE | RACE | Team | Status | AGE_Years | Seniority | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1222391 | XI7007620 | 00-RE114 | IMPORT | XINHUA | PSA/BT/KT | 2 SERAYA P | 2023-12-15 07:30:00 | 2023-12-15 10:00:00 | 2.500000 | 2023-12-15 | 398 | 339 | 1800.0 | 2015-11-02 | 2023-12-31 | CHINESE | Team 1 | 8.0 | 40.75 | 8.16 |
| 1222392 | XI7007620 | 00-RE114 | IMPORT | XINHUA | 2 SERAYA P | 31 GUL CRE | 2023-12-20 09:00:00 | 2023-12-20 10:00:00 | 1.000000 | 2023-12-20 | 169 | 296 | 1800.0 | 2007-12-01 | 2023-12-31 | CHINESE | Team 1 | 9.0 | 55.33 | 16.08 |
| 1222393 | XI7007620 | 00-RE114 | IMPORT | XINHUA | 31 GUL CRE | STOLT NEL | 2023-12-26 09:30:00 | 2023-12-26 10:30:00 | 1.000000 | 2023-12-26 | 398 | 339 | 48.0 | 2015-11-02 | 2023-12-31 | CHINESE | Team 1 | 7.0 | 40.75 | 8.16 |
| 1222394 | XE7046546 | 00-RM123 | EXPORT | XINHUA | JOOKOONCR | PSA/PPT | 2023-12-01 08:00:00 | 2023-12-01 09:45:00 | 1.750000 | 2023-12-01 | 508 | 342 | 1300.0 | 2022-07-05 | 2023-12-31 | MYANMAR | Team 6 | 8.0 | 49.58 | 1.49 |
| 1222396 | TE8037442 | 00-RA186 | EXPORT | MAIN | 42PANDAN1 | PSA/BT/KT | 2023-12-09 07:00:00 | 2023-12-09 08:00:00 | 1.000000 | 2023-12-09 | 4 | 255 | 1772.0 | 2004-02-04 | 2023-12-31 | CHINESE | FCL | 7.0 | 55.75 | 19.90 |
| 1222397 | TE8037442 | 00-RA186 | EXPORT | MAIN | PTC48(G) | 42PANDAN1 | 2023-12-06 09:50:00 | 2023-12-06 10:00:00 | 0.166667 | 2023-12-06 | 220 | 222 | 1772.0 | 2008-03-17 | 2023-12-31 | CHINESE | FCL | 34.0 | 51.33 | 15.79 |
| 1222398 | TL9050450 | 00-RA186 | LOCAL | CHIEN | COGENT TANK 15 | 48DRUMMING | 2023-12-04 10:30:00 | 2023-12-04 12:00:00 | 1.500000 | 2023-12-04 | 37 | 145 | 119.0 | 2004-06-25 | 2023-12-31 | CHINESE | CHIEN LI | 8.0 | 68.25 | 19.52 |
| 1222399 | TL9050450 | 00-RA186 | LOCAL | CHIEN | 48DRUMMING | STOLT NEL | 2023-12-06 05:39:00 | 2023-12-06 05:59:00 | 0.333333 | 2023-12-06 | 302 | 394 | 119.0 | 2008-08-22 | 2023-05-10 | CHINESE | CHIEN LI | 21.0 | 39.08 | 14.71 |
| 1222401 | TE8037521 | 00-RA186 | EXPORT | MAIN | 42PANDAN1 | PSA/PPT | 2023-12-13 09:30:00 | 2023-12-13 10:30:00 | 1.000000 | 2023-12-13 | 110 | 424 | 1937.0 | 2000-11-20 | 2022-10-02 | CHINESE | FCL | 8.0 | 58.92 | 21.86 |
| 1222402 | XE7047519 | 00-RP036 | EXPORT | XINHUA | CONT CONN | PTC MER-GROUND | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 0.000000 | 2023-12-29 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN |
Most frequently occurring
| OrderNumber | CUSTID | JOBTYPE | Department | FROMLOCSTR | TOLOCSTR | STARTTM | ENDTM | TripDuration | CTCOMPLETEDT | DriverId | PrimeMoverId | TrailerId | JOINED DATE | RESIGNED DATE | RACE | Team | Status | AGE_Years | Seniority | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 415 | XE7017181 | 00-RP036 | EXPORT | XINHUA | CHUAN LI Y | PTCISL OFF | 2021-10-19 | 2021-10-19 | 0.0 | 2021-10-19 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 28 |
| 675 | XE7024112 | 00-RP036 | EXPORT | XINHUA | PTCISL OFF | PPT | 2022-03-28 | 2022-03-28 | 0.0 | 2022-03-28 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 28 |
| 694 | XE7024387 | 00-RP036 | EXPORT | XINHUA | PTCISL OFF | PPT | 2022-03-28 | 2022-03-28 | 0.0 | 2022-03-28 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 28 |
| 311 | XE7015494 | 00-RP036 | EXPORT | XINHUA | PTCISL OFF | PPT | 2021-10-06 | 2021-10-06 | 0.0 | 2021-10-06 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 25 |
| 640 | XE7022895 | 00-RP036 | EXPORT | XINHUA | PTCISL OFF | PPT | 2022-03-02 | 2022-03-02 | 0.0 | 2022-03-02 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 23 |
| 682 | XE7024259 | 00-RP036 | EXPORT | XINHUA | PTCISL OFF | PPT | 2022-03-28 | 2022-03-28 | 0.0 | 2022-03-28 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 22 |
| 680 | XE7024259 | 00-RP036 | EXPORT | XINHUA | 47JLNBUROH | PTCISL OFF | 2022-03-25 | 2022-03-25 | 0.0 | 2022-03-25 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 20 |
| 681 | XE7024259 | 00-RP036 | EXPORT | XINHUA | 47JLNBUROH | PTCISL OFF | 2022-03-28 | 2022-03-28 | 0.0 | 2022-03-28 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 20 |
| 1034 | XE7033929 | 00-RP036 | EXPORT | XINHUA | HLA LOGIST | PTCISL OFF | 2022-12-05 | 2022-12-05 | 0.0 | 2022-12-05 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 20 |
| 1035 | XE7033930 | 00-RP036 | EXPORT | XINHUA | HLA LOGIST | PTCISL OFF | 2022-12-07 | 2022-12-07 | 0.0 | 2022-12-07 | 0 | 1001 | NaN | NaT | 2023-12-31 | NaN | NaN | NaN | NaN | NaN | 20 |